package com.ruoyi.politicalstatus.mapper;

import com.ruoyi.politicalstatus.domain.ExamPoliticalStatus;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ExamPoliticalStatusMapper {

    @Select("SELECT * FROM tb_political_status WHERE id = #{id}")
    ExamPoliticalStatus selectPoliticalStatusById(Long id);

    @Select("SELECT * FROM tb_political_status")
    List<ExamPoliticalStatus> selectPoliticalStatusList();

    @Insert("INSERT INTO tb_political_status (name) VALUES (#{name})")
    int insertPoliticalStatus(ExamPoliticalStatus politicalStatus);

    @Update("UPDATE tb_political_status SET name = #{name} WHERE id = #{id}")
    int updatePoliticalStatus(ExamPoliticalStatus politicalStatus);

    @Delete("DELETE FROM tb_political_status WHERE id = #{id}")
    int deletePoliticalStatusById(Long id);
}
